ACA records
The Create ACA Records process should be run once each month for new hires using the appropriate initial calendar period. For the month when the standard measurement period finishes, Create ACA Records must be run twice: once for on-going employees using the standard calendar period and once for new hires using the appropriate initial calendar period.
Create ACA Records uses the most recent ACA category assigned to an employee in performing its analysis. Furthermore, the process limits by check line work date to determine the total number of ACA hours for an employee during a measurement period.
For an initial measurement period, an employee is included in the process if one of the following is true:
- The effective date of the employee's current full-time designation record falls in the range of full-time dates specified for the new hire period.
- The effective date of the employee's part-time/seasonal designation record falls in the range of variable-time dates specified for the new hire period.
During a standard measurement period, an employee is included in the process if the effective date of the designation record created when the employee was last hired is less than the measurement period begin date.
Create an ACA designation record
Whenever an employee is hired, changes status from part-time to full-time or full-time to part-time, or is terminated, you should create an ACA designation record. This helps ensure that ActivityHD handles changes in coverage offers and safe harbor codes accurately when 1095-Cs are generated.
- In the Navigation pane, highlight the Payroll/Human Resources > Employees > Records > ACA folder.
- Click
. The New ACA Record window opens.
- Select the employee code of the Employee for whom you are setting up the ACA designation record.
- Enter a Description of the ACA record.
-
From the Designation drop-down list, select the employee's designated employment status for the purpose of ACA analysis. Your options are:
- Full Time. The employee will average 30 or more hours per week (weekly basis) or 130 or more hours per month (monthly basis).
- Part Time. The employee will average fewer than 30 hours per week (weekly basis) or fewer than 130 hours per month (monthly basis).
- Seasonal. The employee will work on a seasonal basis.
- In the Effective Date field, enter the date that the designated employment status takes effect. For a new hire the effective date is the first day of employment; for a change in status, it's the first day the new status takes effect; for a termination, it's the last day of employment.
- From the Type drop-down list, select "Designation".
- Select the Category the ACA record belongs to.
- Save the new ACA designation record.
Employee designation records are used to determine whether a result record needs to be created for an employee for a selected measurement period. The designation record used in this determination is the most recent designation record with an effective date less than the measurement period's stability period begin date.
To create result records:
- In the Navigation pane, highlight the Payroll/Human Resources > Employees folder.
- Start the Create ACA Records wizard.
- To create ACA records for all or a filtered subset of employees:
- Right-click and select ACA Processing > Select and Create ACA Records from the shortcut menu.
On the Selection tab, define any filters to apply to the data.
- To create ACA records for specifically selected employees:
- In the HD view, select the employees to create ACA records for. You can use Ctrl and/or Shift selection to select multiple employees.
- Click
.
- To create an ACA record for a particular employee from the Employee window:
- In the HD view, locate and double-click the employee you want to create an ACA record for. The Employee window opens with the employee record loaded.
- Click
.
- To create ACA records for all or a filtered subset of employees:
- Select the Options tab.
- Select the ACA Calendar Period to base the ACA records on. Values from the calendar are loaded into the fields in this window.
- To create notification notes for the ACA records you create, mark the Create Notify Notes checkbox.
- In the Date field, enter the date for the notification notes. The default date is the administration period begin date.
- In the Recall Date field, enter the date to follow up on the notification notes. The default date is ten days after the note date.
-
Click Next >>. ActivityHD prompts you to confirm that you want to validate the employees for ACA record creation.
- Click Yes. ActivityHD reports its results.
- Click Next >>. ActivityHD prompts you whether to create the ACA records.
- Click Yes. ActivityHD processes the records and notifies you when the process completes.
- Click Next >>. ActivityHD shows the records you created.
At this point, you can double-click the ACA records in the right pane to drill down to the ACA Record window where you can examine the ACA record, delete an ACA record from the list, or print the ACA Records Listing.
- When you finish viewing or working with the ACA records, click Finish.
Manually create an ACA result record
- In the Navigation pane, highlight the Payroll/Human Resources > Employees > Records > ACA folder.
- Click
. The New ACA Record window opens.
- Select the employee code of the Employee for whom you are setting up the ACA result record.
- Enter a Description of the ACA record.
-
From the Designation drop-down list, select the employee's designated employment status for the purpose of ACA analysis. Your options are:
- Full Time. The employee will average 30 or more hours per week (weekly basis) or 130 or more hours per month (monthly basis).
- Part Time. The employee will average fewer than 30 hours per week (weekly basis) or fewer than 130 hours per month (monthly basis).
- Seasonal. The employee will work on a seasonal basis.
- In the Effective Date field, enter the date that the designated employment status takes effect. For a new hire the effective date is the first day of employment; for a change in status, it's the first day the new status takes effect; for a termination, it's the last day of employment.
- From the Type drop-down list, select "Result".
- Select the Category the ACA record belongs to.
- In the Measurement Period section from the Type drop-down list, select the type of measurement period. Valid values are:
- <blank>. The analysis has never been run for this employee.
- Initial. This is the first time the employee's eligibility for health care has been assessed.
- Standard. This is an analysis other than the initial analysis of the employee's eligibility for health care coverage.
- From the Basis drop-down list, select the type of period the analysis is based on. Valid values are:
- Weekly. The employee's average weekly hours are compared to a 30-hour work week.
- Monthly. The employee's average monthly hours are compared to a 130-hour work month.
- Enter the Begin and End dates of the analysis period.
- The values of the fields in the Employee Offer and Coverage section typically come from the category detail line(s) in effect for the ACA record's effective date and stability period when the Proof/Print 1095-Cs and Create 1095-C Transmission processes are run. Unless you need to override the values from the category detail line(s), continue on to step 13. Otherwise,
expand these instructions to learn how to override the default values:
To override the offer code, mark the checkbox adjacent to the Offer Code field and select the appropriate offer code from the drop-down list. Valid codes are:
- <blank>. If you select this option, the blank will be replaced with 1H when 1095-Cs are generated.
- 1A. The employee received a qualifying offer.
- 1B. Minimum essential coverage providing minimum value was offered to the employee only.
- 1C. Minimum essential coverage providing minimum value was offered to the employee and at least minimum essential coverage was offered to the employee's dependent(s), excluding spouse.
- 1D. Minimum essential coverage providing minimum value was offered to the employee and at least minimum essential coverage was offered to the employee's spouse.
- 1E. Minimum essential coverage providing minimum value was offered to the employee and at least minimum essential coverage was offered to the employee's dependent(s) and spouse.
- 1F. Minimum essential coverage not providing minimum value was offered to the employee, to the employee and spouse or dependent(s), or to the employee, spouse, and dependent(s).
- 1G. Coverage was offered to a non-full-time employee who enrolled in self-insured coverage.
- 1H. Coverage was not offered, or coverage that did not provide minimum essential coverage was offered. This code includes individuals who are employed for one or more months.
- 1I. Reserved (not used for 2016 reporting).
- 1J. Minimum essential coverage providing minimum value was offered to the employee and at least minimum essential coverage was CONDITIONALLY offered to the employee's spouse.
- 1K. Minimum essential coverage providing minimum value was offered to the employee and at least minimum essential coverage was offered to the employee's dependent(s) and CONDITIONALLY offered to the employee's spouse.
The following offer codes were added in tax year 2020 and thereafter.
- 1L. Individual coverage HRA
Health Reimbursement Arrangement offered to employee only with affordability determined by using the ZIP code of the employee's primary residence.
- 1M. Individual coverage HRA
Health Reimbursement Arrangement offered to employee and dependent(s) (not spouse) with affordability determined by using the ZIP code of the employee's primary residence.
- 1N. Individual coverage HRA
Health Reimbursement Arrangement offered to employee, spouse, and dependent(s) with affordability determined by using the ZIP code of the employee's primary residence.
- 1O. Individual coverage HRA
Health Reimbursement Arrangement offered to employee only with affordability determined by using the ZIP code of the employee's primary employment site.
- 1P. Individual coverage HRA
Health Reimbursement Arrangement offered to employee and dependent(s) (not spouse) with affordability determined by using the ZIP code of the employee's primary employment site.
- 1Q. Individual coverage HRA
Health Reimbursement Arrangement offered to employee, spouse, and dependent(s) with affordability determined by using the ZIP code of the employee's primary employment site.
- 1R. Individual coverage HRA
Health Reimbursement Arrangement that is NOT affordable offered to employee; employee and spouse, or dependent(s); or employee, spouse, and dependent(s).
- 1S. Individual coverage HRA
Health Reimbursement Arrangement offered to an individual who was not a full-time employee.
- 1T. Individual coverage HRA
Health Reimbursement Arrangement offered to employee and spouse (no dependents) with affordability determined using employee's private residence ZIP code.
- 1U. Individual coverage HRA
Health Reimbursement Arrangement offered to employee and spouse (no dependents) using employee's primary employment site ZIP code affordability safe harbor.
- 1V - 1Z. Reserved for future use.
- To override the amount of the employee required contribution, mark the checkbox adjacent to the Employee Cost field and enter the correct amount.
- To override the safe harbor code, mark the checkbox adjacent to the Safe Harbor Code field and select the appropriate safe harbor code from the drop-down list. Valid codes are:
- <blank>. No safe harbor code applies.
- 2A. Employee was not employed on any day during the month.
- 2B. Employee was not a full-time employee.
- 2C. Employee enrolled in coverage offered.
- 2D. Employee was in a limited non-assessment period.
- 2E. The multiemployer interim relief rule was applied.
- 2F. Employer is claiming the Form W-2 safe harbor.
- 2G. Employer is claiming the federal poverty line safe harbor.
- 2H. Employer is claiming the rate of pay safe harbor.
- 2I. Reserved for future use.
- To override the plan start month, mark the checkbox next to the Plan Start Month field and enter the month number in the field.
- Save the new ACA results record.
For ACA record-keeping, it is important to track communication with employees regarding their healthcare offers. In particular, you should track offer and expiration of coverage notifications, change of eligibility status notifications, and employee responses to notifications.
The format and the medium for your notifications are up to your organization. However, AccountingWare strongly urges you to refer to ACA documentation for guidelines about the content of notifications and acceptable methods of distributing them. ActivityHD provides notification notes to track when notifications are made and responded to.
Track notifications monthly when you run the Create ACA Records process.
If you need to exclude an ACA record from the Create ACA Records process or any of the 1095-C processes, you can flag the record as voided.
- Open the ACA record you want to flag as voided in Edit mode.
- Mark the Voided checkbox.
- Save your changes.
Purpose
The ACA Records Listing provides a list of ACA records created in Payroll.
Content
For each ACA record included on the report, the listing shows:
- employee code and name
- effective date of ACA record
- record number
- record type
- employee designation (PT/FT)
- ACA category
- dates of stability period
- ACA full-time indicator
- record locked indicator
- voided record indicator.
In addition, you can include one or more of the following:
- offer and coverage (including offer code, employee lowest cost, safe harbor code, plan start month)
- description
- measurement and notifications
- timestamps
- memos
- custom fields.
The following totals appear on the report:
- record count
- employee count.
Print the report
- In the Navigation pane, highlight the Payroll/Human Resources > Employees > Records > ACA folder.
- Start the report set-up wizard.
- To report on all or a filtered subset of ACA records:
- Right-click the ACA folder and select Select and Report > ACA Records Listing from the shortcut menu.
- On the Selection tab, define any filters to apply to the data.
- To report on specifically selected ACA records:
- In the HD view, select the ACA records to include on the report. You can use Ctrl and/or Shift selection to select multiple ACA records.
- Click
and select ACA Records Listing from the drop-down menu.
- To report on a particular ACA record from the ACA Record window:
- In the HD view, locate and double-click the ACA record to report on. The ACA Record window opens with the ACA record loaded.
- Click
and select ACA Records Listing from the drop-down menu.
- To report on all or a filtered subset of ACA records:
- Select the Options tab.
- Mark the checkbox(es) for the additional information to include:
- Offer and Coverage
- Description
- Measurement and Notifications
- Timestamps
- Memos
- Custom Fields (only visible if custom fields are set up)
- Select the Output tab.
- In the Design field, look up and select the report design to use.
- In the toolbar, click the icon for the type of output you want:
- Provides access to two preview options.
- Preview - Click the icon or click the drop-down arrow and select Preview from the drop-down menu to view the report in the Crystal Reports viewer.
- Preview to PDF - Click the drop-down arrow next to the icon and select Preview to PDF to view the report in the PDF reader.
- Opens the Print dialog so that you can select and configure a printer and then print a paper copy of the report.
- Opens the Report Email dialog so that you can address and compose an email that the report will be attached to. For best results, ensure your email client is running before you attempt to send a report via email.
- Opens the Export Report dialog so that you can save the report to a file. File types include Crystal Reports (.rpt), PDF (.pdf), Microsoft Excel (.xls), Microsoft Word (.doc), rich text (.rtf), and XML (.xml).
Data extensions
The following data extensions are available for the report:
- ACA records
- Employees
- ACA categories
ACA Record ID
The code for the employee to whom the ACA record refers. If you are setting up a new ACA record, select the employee code.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
- Full Time. The employee will average 30 or more hours per week (weekly basis) or 130 or more hours per month (monthly basis).
- Part Time. The employee will average fewer than 30 hours per week (weekly basis) or fewer than 130 hours per month (monthly basis).
- Seasonal. The employee will work on a seasonal basis.
On new ACA records, enter the date the employee designation of "Full Time", "Part Time", or "Seasonal" takes effect.
On processed ACA records, this field displays the first day of the stability period that results from the analysis described in this ACA record.
- Designation
- Result
Select the ACA category the employee belongs to.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
ACA Record tab
The type of measurement period. Valid values are:
- <blank>. The analysis has never been run for this employee.
- Initial. This is the first time the employee's eligibility for health care coverage has been assessed.
- Standard. This is an analysis other than the initial analysis of the employee's eligibility for health care coverage.
The type of period the analysis is based on. The basis is specified when the ACA Process is run. Valid values are:
- Weekly. The employee's average weekly hours are compared to a 30-hour work week.
- Monthly. The employee's average monthly hours are compared to a 130-hour work month.
Note
The values for the fields in this section come from the category detail line(s) in effect for the ACA record's effective date and stability period. By default, these fields are blank and the Proof/Print 1095-Cs and Create 1095-C Transmission processes look up the values from the ACA category detail. If the checkboxes are marked and values are specified, those values will override any category detail values in effect for the record's stability period.
- <blank>. If you select this option, the blank will be replaced with 1H when 1095-Cs are generated.
- 1A. The employee received a qualifying offer.
- 1B. Minimum essential coverage providing minimum value was offered to the employee only.
- 1C. Minimum essential coverage providing minimum value was offered to the employee and at least minimum essential coverage was offered to the employee's dependent(s), excluding spouse.
- 1D. Minimum essential coverage providing minimum value was offered to the employee and at least minimum essential coverage was offered to the employee's spouse.
- 1E. Minimum essential coverage providing minimum value was offered to the employee and at least minimum essential coverage was offered to the employee's dependent(s) and spouse.
- 1F. Minimum essential coverage not providing minimum value was offered to the employee, to the employee and spouse or dependent(s), or to the employee, spouse, and dependent(s).
- 1G. Coverage was offered to a non-full-time employee who enrolled in self-insured coverage.
- 1H. Coverage was not offered, or coverage that did not provide minimum essential coverage was offered. This code includes individuals who are employed for one or more months.
- 1I. Reserved (not used for 2016 reporting).
- 1J. Minimum essential coverage providing minimum value was offered to the employee and at least minimum essential coverage was CONDITIONALLY offered to the employee's spouse.
- 1K. Minimum essential coverage providing minimum value was offered to the employee and at least minimum essential coverage was offered to the employee's dependent(s) and CONDITIONALLY offered to the employee's spouse.
The following offer codes were added in tax year 2020 and thereafter.
- 1L. Individual coverage HRA
Health Reimbursement Arrangement offered to employee only with affordability determined by using the ZIP code of the employee's primary residence.
- 1M. Individual coverage HRA
Health Reimbursement Arrangement offered to employee and dependent(s) (not spouse) with affordability determined by using the ZIP code of the employee's primary residence.
- 1N. Individual coverage HRA
Health Reimbursement Arrangement offered to employee, spouse, and dependent(s) with affordability determined by using the ZIP code of the employee's primary residence.
- 1O. Individual coverage HRA
Health Reimbursement Arrangement offered to employee only with affordability determined by using the ZIP code of the employee's primary employment site.
- 1P. Individual coverage HRA
Health Reimbursement Arrangement offered to employee and dependent(s) (not spouse) with affordability determined by using the ZIP code of the employee's primary employment site.
- 1Q. Individual coverage HRA
Health Reimbursement Arrangement offered to employee, spouse, and dependent(s) with affordability determined by using the ZIP code of the employee's primary employment site.
- 1R. Individual coverage HRA
Health Reimbursement Arrangement that is NOT affordable offered to employee; employee and spouse, or dependent(s); or employee, spouse, and dependent(s).
- 1S. Individual coverage HRA
Health Reimbursement Arrangement offered to an individual who was not a full-time employee.
- 1T. Individual coverage HRA
Health Reimbursement Arrangement offered to employee and spouse (no dependents) with affordability determined using employee's private residence ZIP code.
- 1U. Individual coverage HRA
Health Reimbursement Arrangement offered to employee and spouse (no dependents) using employee's primary employment site ZIP code affordability safe harbor.
- 1V - 1Z. Reserved for future use.
If the adjacent checkbox is unmarked, this field defaults to blank. The employee required contribution for self-only minimum essential coverage providing minimum value will be looked up from the ACA category detail line(s) in effect for the ACA record's effective date and stability period. If you need to override the value from ACA category detail, mark the adjacent checkbox and enter the appropriate amount. The amount is used on Form 1095-C only when the corresponding offer code is 1B, 1C, 1D, 1E, 1J, 1K, 1L, 1M, 1N, 1O, 1P, 1Q, 1T, or 1U.
Note
To have the employee required contribution on the 1095-C form remain blank, leave this field blank. If you want 0.00 to print on the form, enter 0. If you enter 1A for the offer code, this field MUST be blank.
- <blank>. No safe harbor code applies.
- 2A. Employee was not employed on any day during the month.
- 2B. Employee was not a full-time employee.
- 2C. Employee enrolled in coverage offered.
- 2D. Employee was in a limited non-assessment period.
- 2E. The multiemployer interim relief rule was applied.
- 2F. Employer is claiming the Form W-2 safe harbor.
- 2G. Employer is claiming the federal poverty line safe harbor.
- 2H. Employer is claiming the rate of pay safe harbor.
- 2I. Reserved for future use.
The number of hours the employee worked during the analysis period.
Note
If there is a discrepancy in the calculated total hours worked and actual hours worked and you need to override the total, press Ctrl+Alt+U or select > Tools > Unlock Hours to enable the field for editing.
The stability period is the length of time for which the analysis results are in effect. For example, if an employee designated as part-time is deemed full-time based on average hours worked during the measurement period, this is the period during which health care coverage is in effect for the employee (if coverage is accepted). If a part-time employee is deemed part-time, this is the period during which no coverage is required regardless of average hours worked during the stability period.
These fields are system-maintained.
When the employee has been offered health care coverage or notified that coverage will expire, select the appropriate notification note. The note should have a note type of "ACANotifyOffer" or "ACANotifyExpire" and a reference to the ACA record.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
When the employee has been notified of a change in their ACA eligibility status, select the appropriate notification note. The note should have a note type of "ACANotified" and a reference to the ACA record.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
When the employee has selected coverage, declined coverage, or acknowledged the expiration of coverage, select the appropriate notification note. The note should have a note type of "ACASelected", "ACADeclined", or "ACAExpireAcknowledged" and a reference to the ACA record.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
Custom tab
This tab is visible if custom fields exist for the entity. At a minimum, if there are custom fields, a Fields subtab will be present. One or more additional categories of subtabs may also be visible.
Fields subtab
This tab prompts for values for any custom fields set up for entity records of this entity type. Respond to the prompts as appropriate.
References subtab
This tab is visible if other records reference the current record.
Example
Suppose a custom field exists on PRCodes that references an ARCode. On the ARCode record, on the Custom > References subtab, you can view all the PRCodes which reference that ARCode.
Exchange Folder subtab
This tab is visible only if you set up a custom field with a data type of "Exchange Folder". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified Exchange folder.
File subtab
This tab is visible only if you set up a custom field with a data type of "File". The label on the tab is the name assigned to the custom field.
This tab renders the contents of the specified file according to its file type.
Internet Address subtab
This tab is visible only if you set up a custom field with a data type of "Internet Address". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified web page.
Network Folder subtab
This tab is visible only if you set up a custom field with a data type of "Network Folder". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified network folder.
Notes tab
Note
Notes created from the Notes tab automatically have the current ACA record and the associated employee added as references.
The Notes pane shows the Notes HD view filtered to show all notes for the selected ACA record.
Double-click a row in the pane to drill down to its record in the Note window.
Attachments tab
The Attachments tab is visible if any record for a given entity has an attachment. If the Attachments tab is not visible, this implies that no record of the entity type has an attachment on it; however, once an attachment is added to any record of the entity type, the Attachments tab will become available.
Other tab
![]() |
Extras\Payroll\Import Employee ACA Records.xls |
ACA records security
Common accesses available on ACA records
Special accesses available on ACA records
Access | A user with this access can... |
---|---|
Create | Create ACA records. |
Lock | Lock/unlock ACA records. |
Report Email dialog
- Windows user default account. Sends email using the user's Windows default email account. For most users, this is the account configured in Outlook or another email client application.
- Server personal. Sends email using the email configuration for the system or company server and the email address on the current user's authorized user record. The authorized user record must have a confirmed email address.
- Server generic. Sends email using the email configuration and "from" address for the system or company server. This option requires "Send generic" access to the Server Email resource.
5225 S Loop 289, #207 Lubbock, TX 79424 806.687.8500 | 800.354.7152 |
© 2025 AccountingWare, LLC All rights reserved. |